Create Sample Azure SQL Server and Database

How to create a single database and server in Azure SQL Database

Azure
SQL Database
Server
Single Database
Author

Phuong Nguyen

Published

December 29, 2024

Hi there,

In this guide, I will walk you through the process of creating a single database in Azure SQL Database. Once created, you can query the database using the Query Editor in the Azure portal.

Prerequisites

To complete this task, you must have an active Azure subscription. If you do not have one yet, you can create a free account by following this link: Azure Free Account

Creating a Single Azure SQL Database

Step 1: Access Azure SQL Databases

  1. Go to the Microsoft Azure Portal
  2. On the homepage, click on the SQL Databases icon.

Step 2: Create a New SQL Database

  1. On the SQL Databases page, click Create SQL Database.

Step 3: Configure Database Settings

Basics Tab:

  1. Select the desired Azure Subscription.
  2. For the Resource group, click Create new, enter a name, and click OK.
  3. Enter the Database name (requirements: maximum 128 characters, no reserved words, and no existing database with the same name on the server).
  4. For Server, select Create new and proceed as follows:

o Enter a Server name (Azure will notify you if the name is available). o Select the Location from the dropdown list. o For Authentication method, choose SQL Authentication.  Create a Server Admin Login.  Set a password.  Click OK.

Workload Environment

  1. Under Workload environment, select either Development or Production. Note that the fees differ significantly between these options.
  2. Click Next to proceed to the Networking tab

Networking Tab

  1. Choose the connectivity method (e.g., Public endpoint).
  2. Under Firewall rules, enable: o Allow Azure services and resources to access this server. o Add current client IP address.

Additional Settings Tab

  1. In the Data source section, select Sample.
  2. Click OK.

Step 4: Review and Create

  1. Review all information in the Tags and Review + create tabs.
  2. Click Create to finalize the database creation.

Final Result

You have successfully created a sample Azure SQL Database. You can now query and manage your database directly from the Azure portal

To give you a hands-on practice of this use case, please following my step-by-step tutorial video to perform all the above steps:

Reference

https://learn.microsoft.com/en-us/azure/azure-sql/database